List Month Days
Month Number is shown in A1
Formula below is entered in A2 and dragged to A32
=IF(ROW()-1<=DAY(DATE(YEAR(TODAY()),$A$1+1,0)),ROW()-1,"")
The days shown in A2:A32 will change according to the month shown in A1.
© Copyright
andrewsexceltips.net
All Rights Reserved.